﻿using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.Base
{
    class clsConstBasicListFuction
    {
        public class ClsExpenceFuction
        {
            public const string GetAll = "sp_242_Expence_GetAll";
            public const string Insert = "sp_242_Expence_Insert";
            public const string Delete = "sp_242_Expence_Delete";
            public const string Update = "sp_242_Expence_Update";
        }

        public class ClsJigFuction
        {
            public const string GetAll = "sp_242_Jig_GetAll";
            public const string Insert = "sp_242_Jig_Insert";
            public const string Delete = "sp_242_Jig_Delete";
            public const string Update = "sp_242_Jig_Update";
        }

        public class ClsCustomerFuction
        {
            public const string GetAll = "sp_242_Customer_GetAll";
            public const string Insert = "sp_242_Customer_Insert";
            public const string Delete = "sp_242_Customer_Delete";
            public const string Update = "sp_242_Customer_Update";
        }

        public class ClsOvertimeFuction
        {
            public const string GetAll = "sp_242_Overtime_GetAll";
            public const string Insert = "sp_242_Overtime_Insert";
            public const string Delete = "sp_242_Overtime_Delete";
            public const string Update = "sp_242_Overtime_Update";
        }

        public class ClsSectionFuction
        {
            public const string GetAll = "sp_242_Section_GetAll";
            public const string Insert = "sp_242_Section_Insert";
            public const string Delete = "sp_242_Section_Delete";
            public const string Update = "sp_242_Section_Update";
        }

        public class ClsXLBMFuction
        {
            public class ClsMeMa
            {
                public const string GetAll = "sp_242_MeMa_GetAll";
                public const string Insert = "sp_242_MeMa_Insert";
                public const string Delete = "sp_242_MeMa_Delete";
                public const string Update = "sp_242_MeMa_Update";
            }

            public class ClsAnoData
            {
                public const string GetAll = "sp_242_DulieuANO_GetAll";
                public const string GetAllByID = "sp_242_DulieuANO_GetAllByID";
                public const string Insert = "sp_242_DulieuANO_Insert";
                public const string Delete = "sp_242_DulieuANO_Delete";
                public const string Update = "sp_242_DulieuANO_Update";

                public const string GetAllMONo = "sp_242_MO_GetAllAnoData";
                public const string GetAllMONoAnoData = "sp_242_MO_GetAllMONoAnoData";
                public const string GetAllMONoAnoData1 = "sp_242_MO_GetAllMONoAnoData1";
                public const string getDulieuslMa = "sp_242_DulieuslMa";
                public const string GetPartID = "sp_242_GetPartIDByOder";

                public const string KHHN = "sp_242_XLBM_KHhangngay";
                public const string KHT = "sp_242_XLBM_KHTong";
                public const string HT = "StockinXLBM";
            }
        }

        public class ClsWorkFuction
        {
            public const string GetAll = "sp_242_Work_GetAll";
            public const string Insert = "sp_242_Work_Insert";
            public const string Delete = "sp_242_Work_Delete";
            public const string Update = "sp_242_Work_Update";
        }

        public class ClsReportFuction
        {
            public class GC
            {
                public const string GetAll = "sp_242_KH-NhaplenhtinhthoigianGC";
                public const string GetAllKHTon = "sp_242_KH-TGGCcacdonhangtinhKH02";
                public const string Insert = "sp_242_Work_Insert";
                public const string Delete = "sp_242_Work_Delete";
                public const string Update = "sp_242_Work_Update";
            }
            public class KHGC
            {
                public const string GetAll = "sp_242_NhapOrderlapKHGC";
                public const string GetAllDLM = "sp_242_Dulieudonhangmoi";
                public const string GetAllKHGC03 = "sp_242_KHGC_GetAll";
                public const string Insert = "sp_242_Work_Insert";
                public const string Delete = "sp_242_Work_Delete";
                public const string Update = "sp_242_Work_Update";
            }

            public class KHKT
            {
                public const string GetAll = "sp_242_NhapOrderlapKHKtra";
                public const string GetAllKHKT24 = "sp_242_P_LayNClamKHVia";
                public const string Insert = "sp_242_Work_Insert";
                public const string Delete = "sp_242_Work_Delete";
                public const string Update = "sp_242_Work_Update";
            }
            public class KHNCV
            {
                public const string GetAll = "sp_242_NhapOrderlapKHNCV";
                public const string GetAllKHNCV24 = "sp_242_P_LayNClamKHVia";
                public const string GetAllKHNCV25 = "sp_242_P_LayNClamKHKtra";
                public const string GetAllKHNCV26 = "Sp_Rpt_242_TK_CongsuatKHKtra_Hoan";
                public const string Delete = "sp_242_Work_Delete";
                public const string Update = "sp_242_Work_Update";
            }
            public class KHKT06
            {
                public const string GetAllDHMN = "sp_242_XTDonhangmuangoai";
                public const string GetAllTnhapOder = "sp_242_Tnhaporder";
                public const string GetAllKHKT06 = "Sp_242_Rpt_XThanh_LayNCtamthoi";
            }
            //các báo cáo trong file LinkVCuong
            public class OTHER  
            {
                public const string GetAllZDH = "Sp_242_Rpt_ZDH";
                public const string GetAllXThanh_LayNCtamthoi = "Sp_242_Rpt_XThanh_LayNCtamthoi";
                public const string VIAKTRA = "Sp_242_Rpt_VitrihangVIA_KTRA";
                public const string GetAllMAVIA = "Sp_242_Rpt_VitrihangMAY_VIA";
                public const string GetAllXLBM = "Sp_242_Rpt_VanthongkedulieuXLBM";
                public const string GetAllDLVIA = "Sp_242_Rpt_VanthongkedulieuVIA";
                public const string GetAllDLKTRA = "Sp_242_Rpt_VanthongkedulieuKTra";
                public const string GetAllUDONHANG = "Sp_242_Rpt_Udonhang";
                public const string GetAllUDHKH = "Sp_242_Rpt_UDH_KH";
                public const string GetAllKHTrongThang = "Sp_242_Rpt_TK_HoanthanhKHtrongthang";
                public const string GetAllCongSuatMay = "Sp_242_Rpt_TK_Congsuatmay";
                public const string GetAllCongSuatKHVia = "Sp_242_Rpt_TK_CongsuatKHVia";
                public const string GetAllCongSuatKHKTra = "Sp_Rpt_242_TK_CongsuatKHKtra";
                public const string GetAllQStaffDailyTime = "Sp_Rpt_242_QStaffDailyTime";
                public const string GetAllQMachineDailyTime = "Sp_Rpt_242_QMachineDailyTime";
                public const string GetAllInsDataLuu = "Sp_Rpt_242_P_InsData_Luu";
                public const string GetAllTGConLaiDH02 = "Sp_242_Rpt_KH_TGconlaicuadonhang02";
                public const string GetAllPIN1 = "Sp_242_Rpt_Le_Laydulieu_PIN1";
                public const string GetAllTGConLaiDH01 = "Sp_242_Rpt_KH_TGconlaicuadonhang01Query";
                public const string GetAllDonHangChuaXinLenh = "Sp_242_Rpt_KH_DonhangchuaXINLENH";
                public const string GetAllDonHangChuaStart = "Sp_242_Rpt_KH_DonhangchuaSTART";
                public const string GetAllThanh0673 = "Sp_242_Rpt_InsTime_Thanh0673";
            }
            public class TableImport
            {
                public const string Tnhaporder = "sp_242_Tnhaporder_GetAll";
                public const string XTDonhangmuangoai = "sp_242_XTDonhangmuangoai_GetAll";
                public const string NhapOrderDonHangChuyenKho = "sp_242_NhapOrderDonHangChuyenKho_GetAll";
                public const string HENKH = "sp_242_HENKH_GetAll";

                public const string MachineWTS_Temp = "sp_242_MachineWTS_Temp_GetAll";
                public const string WorkName = "sp_242_WorkName_GetAll";
                public const string Shift = "sp_242_Shift_GetAll";

                // dùng trong file NG nội bộ
                public const string Thuy0480 = "sp_242_Thuy0480_GetAll";
                public const string InternalNGDetails = "sp_242_InternalNGDetails_GetAll";
                public const string MachineList = "sp_242_MachineList_GetAll";
                public const string MistakeList = "sp_242_MistakeList_GetAll";
                public const string CauseList = "sp_242_CauseList_GetAll";

                //dùng trong file Báo cáo thời gian làm việc tháng
                public const string TimeCard = "sp_242_TimeCard_GetAll";
                public const string StaffList = "sp_242_StaffList_GetAll";
                public const string StaffList1 = "sp_242_StaffList1_GetAll";
                public const string TimeCard1 = "sp_242_TimeCard1_GetAll";
            }

            public class TableDelete
            {
                public const string Tnhaporder = "sp_Delete_242_Tnhaporder_Delete";
                public const string XTDonhangmuangoai = "sp_Delete_242_XTDonhangmuangoai_Delete";
                public const string NhapOrderDonHangChuyenKho = "sp_Delete_242_NhapOrderDonHangChuyenKho_Delete";
                public const string HENKH = "sp_Delete_242_HENKH_GetAll";

                public const string NhaplenhtinhthoigianGC = "sp_Delete_242_KH-NhaplenhtinhthoigianGC";
                public const string NhapOrderlapKHGC = "sp_Delete_242_NhapOrderlapKHGC";
                public const string NhapOrderlapKHNCV = "sp_Delete_242_NhapOrderlapKHNCV";
                public const string NhapOrderlapKHKtra = "sp_Delete_242_NhapOrderlapKHKtra";

                public const string MachineWTS_Temp = "sp_Delete_242_MachineWTS_Temp_Delete";
                public const string WorkName = "sp_Delete_242_WorkName_Delete";
                public const string Shift = "sp_Delete_242_Shift_Delete";

                // dùng trong file NG nội bộ
                public const string Thuy0480 = "sp_DElete_242_Thuy0480_Delete";
                public const string InternalNGDetails = "sp_Delete_242_InternalNGDetails_Delete";
                public const string MachineList = "sp_Delete_242_MachineList_Delete";
                public const string MistakeList = "sp_Delete_242_MistakeList_Delete";
                public const string CauseList = "sp_Delete_242_CauseList_Delete";

                //dùng trong file Báo cáo thời gian làm việc tháng
                public const string TimeCard = "sp_Delete_242_TimeCard_Delete";
                public const string StaffList = "sp_Delete_242_StaffList_Delete";
                public const string StaffList1 = "sp_Delete_242_StaffList1_Delete";
                public const string TimeCard1 = "sp_Delete_242_TimeCard1_Delete";
            }
            //các báo cáo trong file báo cáo kế hoạch
            public class BCKH
            {
                public const string PWTSDelete = "Sp_242_Rpt_PWTSDelete";
                public const string PWTSUpdate = "Sp_242_Rpt_PWTSUpdate";
                public const string QBCBieuThoigianchaymayNgayVN = "Sp_242_Rpt_QBCBieuThoigianchaymayNgay_VN";
                public const string QBCBieuthoigianchaymayNgayJP = "Sp_242_Rpt_QBCBieuThoigianchaymayNgay_JP";
                public const string QTGCMCross_CrosstabVN = "Sp_242_Rpt_QTGCMCross_CrosstabVN";
                public const string QTGCMCross_CrosstabJP = "Sp_242_Rpt_QTGCMCross_CrosstabJP";
                public const string QBChangNG = "Sp_242_Rpt_QBChangNG";
                public const string Qketquagiaconghangloat = "Sp_242_Rpt_Qketquagiaconghangloat";
                public const string Qketquachaythu = "Sp_242_Rpt_Qketquachaythu";
            }
        }
    }
}
